CREATE TABLE [dbo].[SiteContent]
(
[SiteContentId] [int] NOT NULL IDENTITY(1, 1),
[ParentSiteContentId] [int] NULL,
[Title] [nvarchar] (150) COLLATE Cyrillic_General_CI_AS NOT NULL,
[Content] [nvarchar] (max) COLLATE Cyrillic_General_CI_AS NULL,
[ContentTypeCode] [int] NOT NULL,
[IsDeleted] [bit] NOT NULL,
[IsVisible] [bit] NOT NULL,
[CreateDate] [datetime] NOT NULL,
[LastModifiedDate] [datetime] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
ALTER TABLE [dbo].[SiteContent] ADD
CONSTRAINT [FK_SiteContent_SiteContent] FOREIGN KEY ([ParentSiteContentId]) REFERENCES [dbo].[SiteContent] ([SiteContentId])
GO
ALTER TABLE [dbo].[SiteContent] ADD CONSTRAINT [PK_SiteContent_1] PRIMARY KEY CLUSTERED  ([SiteContentId]) ON [PRIMARY]
GO
